Attribute | Description | Physical Name | Domain | Data Type | Foreign Key Table |
ItemID (FK)(PK) | A unique system assigned identifier for the retailer's SKU. | ID_ITM | IdentityUUID | char(32) | StockItem(AS_ITM_STK) |
DispositionCode | A code to denote how the DISPLAY UNIT is to be disposed, ie returned to the supplier, destroyed, or retained until the next promotion. | DP_UN_DPLY | Code2 | char(2) | |
TakeDownDate | The date on which the display unit can be taken down by the RETAIL STORE | DC_UN_DPLY_TK_DWN | DateCalendar | date | |
SetupDate | The date on which the DISPLAY UNIT can be setup within the RETAIL STORE | DC_UN_DPLY_ST_UP | DateCalendar | date | |
DisplayUnitTypeCode | A code to denote the type of display unit, i.e. free-standing, shelf end, refrigerator, etc. | TY_UN_DPLY | Code2 | char(2) | |
ShelfItemsHeldCapacityCount | The maximum number of SHELF ITEMS that can be stocked on the DISPLAY UNIT. | QU_CPC_HLD | Quantity | DECIMAL(9,3) | |